Execute Macro

Command Prototype

objRet = Excel.ExecuteMacro(objExcelWorkBook,macro,listArgs)

Command Description

Execute macros in Excel

Parameter Description

Required Parameter

objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))

macro--Macro definition in Excel, can be sub, function

listArgs--The parameters to be passed to the macro definition, for example, to call subSum(1,2), pass [1,2]

return

objRet--The variable used to save the output of the function call